SELECT country_id,country_name
FROM   countries
MINUS
SELECT l.country_id,c.country_name
FROM   locations l JOIN  countries c
ON     (l.country_id = c.country_id);

